Products
In-IDE
IDE extension that lets you fix coding issues before they exist!
Discover SonarLint
SaaS
Setup is effortless and analysis is automatic for most languages
Discover SonarCloud
Self-Hosted
Fast, accurate analysis; enterprise scalability
Discover SonarQube

PL/SQL static code analysis

Unique rules to find Bugs, Vulnerabilities, Security Hotspots, and Code Smells in your PL/SQL code

Features deprecated in Oracle 12 should not be used

consistency - conventional

maintainability

Code Smell

MajorSonarSource default severity
click to learn more

Why is this an issue?

More Info

Deprecated language features have been retained temporarily for backward compatibility but will eventually be removed from the language. Deprecation announces a grace period to allow a smooth transition from the old features to the new ones. In that period, no use of the deprecated features should be added to the code, and all existing usages should be gradually removed.

The following features are deprecated in Oracle 12:

Deprecated	Replacement
DBMS_DDL.ALTER_COMPILE	Native Dynamic SQL
ALL_SCHEDULER_CREDENTIALS	ALL_CREDENTIALS
DBA_NETWORK_ACL_PRIVILEGES	DBA_HOST_ACES
DBA_NETWORK_ACLS	DBA_HOST_ACLS
DBA_SCHEDULER_CREDENTIALS	DBA_CREDENTIALS
USER_NETWORK_ACL_PRIVILEGES	USER_HOST_ACES
USER_SCHEDULER_CREDENTIALS	DBA_HOST_ACES
V$OBJECT_USAGE	USER_OBJECT_USAGE
SYS_XMLGEN	SQL/XML-generation functions
EXISTSNODE	XMLEXISTS
DELETEXML	XQuery Update
APPENDCHILDXML	XQuery Update
INSERTCHILDXML	XQuery Update
INSERTXMLBEFORE	XQuery Update
INSERTXMLAFTER	XQuery Update
INSERTCHILDXMLBEFORE	XQuery Update
INSERTCHILDXMLAFTER	XQuery Update
UPDATEXML	XQuery Update
EXTRACTVALUE	XMLTABLE, or the XMLCAST and XMLQUERY
XMLSEQUENCE	XMLTABLE

Available In:

Catch issues on the fly,
in your IDE

Detect issues in your GitHub, Azure DevOps Services, Bitbucket Cloud, GitLab repositories

Developer
Edition

In-IDE

SaaS

Self-Hosted